Scalar functions for changing the case of text strings
Format
ANSI-SQL Format:
{ UPPER | LOWER } ( expression )
ODBC Format:
{{ FN { UCASE | LCASE } ( expression ) }}
Remarks
The scalar function UPPER converts all lower case characters to upper case. The scalar function LOWER converts all upper case characters to lower case.
The equivalent ODBC functions are UCASE and LCASE.
Example:
UPPER( CurrentStateDesc )
{FN LCASE( CurrentStateDesc )}